1
2 <?php
3 include_once 'header.php';
4 ?>
5 <html>
6 <head>
7 <title>Signup</title>
8 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
9
10 <!-- Optional theme -->
11 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
12
13 <!-- Latest compiled and minified JavaScript -->
14 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
15 </head>
16 <style>
17 table,th,td
18 {
19 font-family: monospace;
20 font-size: 150%;
21 padding: 0.25cm;
22 border:2px color:transparent;
23 background-color: black;
24
25 }
26 body{
27 background-image: url("images/jl.jpg");
28 background-size:100%;
29 color: white;
30 }
31 button
32 {
33 display: block;
34 margin: 0 auto;
35 width: 10%;
36 height: 40px;
37 border: none;
38 background-color: #222;
39 font-family: arial;
40 font-size: 16px;
41 color: #fff;
42 cursor: pointer;
43 }
44 </style>
45
46
47
48 <head>
49 <h1 align="middle" style="font-size: 500%; color: black;"><u>Justice League</u></h1>
50 </head>
51
52
53 <body style="background-color: powderblue; font-family: monospace; margin: 0; padding: 0;">
54 <h1> </h1>
55 <p align=middle>
56 <video width="700" height="545" controls >
57 <source src="video/jl.mp4" type="video/mp4">
58 </video>
59 <h1 align="middle" style="font-size: 300%; color: black"><u><b>Trailer</b></u></h1>
60 </p>
61
62 <br><br><br><br>
63
64 <?php
65 $dbServername = "localhost";
66 $dbUsername = "root";
67 $dbPassword = "password";
68 $dbName = "test";
69
70 $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
71
72 $sql="SELECT description,genre,mov_lang,dir_name,stars from movie m,director d,rating r where d.dir_id=m.dir_id and r.mov_id=m.mov_id and mov_name='Justice League'; ";
73 mysqli_query($conn, $sql) or die('Error');
74 $result = mysqli_query($conn, $sql);
75 while($row=mysqli_fetch_array($result))
76 {
77 echo '<table style="margin-right:10%; margin-left:10%;">
78
79 <tr>
80 <td><u><b> Description</b></u></td>
81 <td>'.$row['description'].'</td>
82 </tr>
83 <tr>
84 <td><u> <b>Genre</b></u></td>
85 <td>'.$row['genre'].'</td>
86 </tr>
87 <tr>
88 <td><u><b> Language</b> </u></td>
89 <td>'.$row['mov_lang'].'</td>
90 </tr>
91 <tr>
92 <td><u> <b>Director</b> </u></td>
93 <td>'.$row['dir_name'].'</td>
94 </tr>
95 <tr>
96 <td><u><b>Rating</b> </u></td>
97 <td>'.$row['stars'].'</td>
98 </tr>
99 </table><br><br><br>';
100 }
101 ?>
102
103 <h1 align="middle" style="font-size: 300%;color:black;"><br><b><u>Cast</u></b></h1>
104
105 <?php
106 $sql1="SELECT actor_name,role from actor a,movie m,movie_cast mc where a.actor_id=mc.actor_id and mc.mov_id=m.mov_id and m.mov_name='Justice League';";
107 mysqli_query($conn, $sql) or die('Error');
108 $result1 = mysqli_query($conn, $sql1);
109 echo '<br><table style="margin-left: auto; margin-right: auto;">
110 <tr align="middle">
111 <td><u><b>Actor</u></td>
112 <td><u><b>Role</u></td>
113 </tr>';
114 while($row=mysqli_fetch_array($result1))
115 {
116 echo '<tr >
117 <td>'.$row['actor_name'].'</td>
118 <td align="middle">'.$row['role'].'</td>
119 </tr>';
120 }
121
122 echo '</table><br><br><br>';
123
124 $_SESSION['mov_name']="Justice League";
125
126 ?>
127
128 <center><a href="nowshowing.php" class="btn btn-default btn-lg" style="font-size:15px padding-top:0.25%; font-family: comic sans ms; color: black" role="button"><b>Book now</b></a></center><br>
129
130 </body>
131 </html>
132
133 <?php
134 include_once 'footer.php';
135 ?>
